package com.cyf.db.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zym
 * @date 2020/6/23 7:15
 */
@Mapper
public interface ApiUserParkingMapper {
    @Select("select apiUserId from api_userparking where parkingId = #{parkingId} and apiUserId != 1 order by apiUserId ")
    List<Integer> listApiUserIdNoCyfForIsvpayByParkingId(@Param("parkingId") int parkingId);

    //查询 parkingId
    @Select("SELECT  parkingId FROM api_userparking WHERE apiUserId=#{apiUserId}")
    List<Integer> getParkingIdByApiUserId(@Param("apiUserId") int apiUserId);


}
